<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;

class CreateYsBookRecommendsTable extends Migration {

	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
		Schema::create('book_recommends', function(Blueprint $table)
		{
			$table->increments('id');
			$table->bigInteger('book_id')->unsigned()->index('book_recommends_book_id_index');
			$table->timestamp('heavy_at')->nullable()->comment('重磅推荐，无为null 有为推荐时间');
			$table->timestamp('masterpiece_at')->nullable()->comment('最新力作，无为null 有为推荐时间');
			$table->timestamp('recommend_at')->nullable()->comment('偏偏君子和窈窕淑女两个频道的推荐，无为null 有为推荐时间');
			$table->timestamp('ys_recommend_at')->nullable()->comment('小言推荐时间');
			$table->timestamp('week_choiceness_at')->nullable()->comment('本周推荐时间');
            $table->timestamps();
		});
	}


	/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down()
	{
		Schema::drop('book_recommends');
	}

}
